package com.ssm.dao;

import com.ssm.domain.Traveller;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ITravellerDao {

    @Select("select t.id, t.name, t.sex, t.phoneNum, t.credentialsType, t.credentialsNum, t.travellerType from traveller t left join order_traveller o_t on travellerid =  t.id where O_t.orderid = #{orderId}")
    List<Traveller> findByOrderId(String orderId) throws Exception;
}
